﻿/* dk2Repository - Copyright (C) 2011 Daniel Kuczewski http://www.dk2.de/

 * This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA */

using System.Collections.Generic;

namespace dk2Repository.QueryBuilder
{
    internal abstract class SelectBuilder : SqlBuilderBase
    {
        private readonly ISqlBuilder _builder;
        private readonly List<string> _joins;
        private readonly List<string> _columns;
        private readonly List<string> _orders;

        protected string[] Joins { get { return _joins.ToArray(); } }
        protected string[] Columns { get { return _columns.ToArray(); } }
        protected string[] Orders { get { return _orders.ToArray(); } }

        public WhereBuilder Where { get; private set; }




        protected SelectBuilder(ISqlBuilder builder)
        {
            _builder = builder;
            _joins = new List<string>();
            _columns = new List<string>();
            _orders = new List<string>();

            Where = builder.CreateWhereBuilder();
            
            
        }

        public void AddColumn(string column)
        {
            _columns.Add(column);
        }

        public void AddColumn(string column, string alias)
        {
            _columns.Add(column + " " + alias);
        }

        public void AddOrder(string column, EnumOrderMethod orderMethod)
        {
            _orders.Add(_builder.CreateOrderString(column, orderMethod));
        }

        public void AddOrder(string order)
        {
            _orders.Add(order);
        }

        public void AddJoin(EnumJoinMode joinmode, string lefttable, string righttable, string leftcol, string rightcol)
        {
            _joins.Add(_builder.CreateJoinString(joinmode, lefttable, righttable, leftcol, rightcol));
        }

        public void AddJoin(string join)
        {
            _joins.Add(join);
        }

        public abstract override string CreateSql();
    }
}